

create database my_database on primary
(
	name = 'my_database_db',
	filename = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\my_database.mdf',
	size = 5120kb,
	maxsize = 30mb,
	filegrowth = 5%
)
log on
(
	name = 'my_database_log',
	filename = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\my_database.ldf',
	size = 1024kb,
	maxsize = 8192kb,
	filegrowth = 10%
)
go